FO_IFxFacilityID

This table contains the mapping of various interfaces for each facility ID. This is used by ITP to direct triggering to the correct trigger table / interface.

 

Field Type Notes

FO_IFxFacilityID_ID

int

ID field, a counter. Unique

FacilityID

varchar(50)

Enter a unique facility ID.

Usually a numeric hospital ID.

ADTinterfaces

varchar(255)

Defines a list of ADT interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid ADT interface codes separated by pipes.

OEinterfaces

varchar(255)

Defines a list of OE interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid OE interface codes separated by pipes.

RESinterfaces

varchar(255)

Defines a list of RES interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid RES interface codes separated by pipes.

CDCInbound

varchar(255)

Defines a list of CDC inbound interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid CDC inbound interface codes separated by pipes.

CDCOutbound

varchar(255)

Defines a list of CDC outbound interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid CDC outbound interface codes separated by pipes.

TDCInbound

varchar(255)

Defines a list of TDC inbound interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid TDC inbound interface codes separated by pipes.

TDCOutbound

varchar(255)

Defines a list of TDC outbound interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid TDC outbound interface codes separated by pipes.

FPToRREOutbound

varchar(50)

Defines a list of FPToRRE outbound interface codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid FPToRRE outbound interface codes separated by pipes.

FacilityIDCode

varchar(50)

Enter a unique facility ID code.

FacilityName

varchar(80)

Enter full name for this facility.

MPIQualifier

varchar(50)

Enter a valid MPI Qualifier code.